Data

row

Data

row_id order_id order_date ship_date ship_mode customer_id customer_name segment country city state postal_code region product_id category sub-category product_name sales quantity discount profit
9425 CA-2014-145254 7/23/2014 7/27/2014 Standard Class NC-18535 Nick Crebassa Corporate United States San Francisco California 94122 West TEC-AC-10002167 Technology Accessories Imation<U+00A0>8gb Micro Traveldrive Usb 2.0<U+00A0>Flash Drive 45.000 3 0.0 4.9500
7480 CA-2014-167199 1/6/2014 1/10/2014 Standard Class ME-17320 Maria Etezadi Home Office United States Henderson Kentucky 42420 South OFF-FA-10001883 Office Supplies Fasteners Alliance Super-Size Bands, Assorted Sizes 31.120 4 0.0 0.3112
4054 CA-2014-122931 9/29/2014 10/3/2014 Standard Class SM-20950 Suzanne McNair Corporate United States Philadelphia Pennsylvania 19134 East OFF-LA-10002945 Office Supplies Labels Permanent Self-Adhesive File Folder Labels for Typewriters, 1 1/8 x 3 1/2, White 55.440 11 0.2 18.0180
7805 CA-2015-102260 9/22/2015 9/26/2015 Standard Class SJ-20125 Sanjit Jacobs Home Office United States Franklin Tennessee 37064 South OFF-ST-10002289 Office Supplies Storage Safco Wire Cube Shelving System, For Use as 4 or 5 14” Cubes, Black 25.424 1 0.2 -4.7670
6752 CA-2016-154767 6/28/2016 6/30/2016 Second Class BP-11155 Becky Pak Consumer United States Paterson New Jersey 7501 East OFF-AP-10000595 Office Supplies Appliances Disposable Triple-Filter Dust Bags 8.740 2 0.0 2.2724
4585 US-2017-163790 11/2/2017 11/4/2017 Second Class NL-18310 Nancy Lomonaco Home Office United States Danville California 94526 West OFF-EN-10001335 Office Supplies Envelopes White Business Envelopes with Contemporary Seam, Recycled White Business Envelopes 76.580 7 0.0 38.2900
7999 US-2014-148194 5/4/2014 5/7/2014 First Class BS-11365 Bill Shonely Corporate United States Seattle Washington 98105 West FUR-FU-10001852 Furniture Furnishings Eldon Regeneration Recycled Desk Accessories, Smoke 12.180 7 0.0 3.8976
2688 US-2016-128195 8/4/2016 8/5/2016 First Class RA-19285 Ralph Arnett Consumer United States Peoria Illinois 61604 Central OFF-BI-10002003 Office Supplies Binders Ibico Presentation Index for Binding Systems 3.980 5 0.8 -6.5670
5609 CA-2015-168634 12/6/2015 12/11/2015 Standard Class AF-10870 Art Ferguson Consumer United States San Francisco California 94109 West OFF-AP-10001626 Office Supplies Appliances Commercial WindTunnel Clean Air Upright Vacuum, Replacement Belts, Filtration Bags 7.780 2 0.0 2.0228
8816 CA-2015-144274 11/23/2015 11/25/2015 Second Class PW-19240 Pierre Wener Consumer United States Wilmington Delaware 19805 East OFF-PA-10001583 Office Supplies Paper 1/4 Fold Party Design Invitations & White Envelopes, 24 8-1/2” X 11” Cards, 25 Env./Pack 44.100 6 0.0 20.7270
4853 CA-2014-107818 9/8/2014 9/14/2014 Standard Class MC-17275 Marc Crier Consumer United States Pasco Washington 99301 West OFF-ST-10000736 Office Supplies Storage Carina Double Wide Media Storage Towers in Natural & Black 485.880 6 0.0 19.4352
235 US-2017-100930 4/7/2017 4/12/2017 Standard Class CS-12400 Christopher Schild Home Office United States Tampa Florida 33614 South FUR-FU-10004017 Furniture Furnishings Tenex Contemporary Contur Chairmats for Low and Medium Pile Carpet, Computer, 39” x 49” 258.072 3 0.2 0.0000
4547 CA-2015-126557 7/12/2015 7/17/2015 Second Class RL-19615 Rob Lucas Consumer United States Chicago Illinois 60610 Central OFF-BI-10003314 Office Supplies Binders Tuff Stuff Recycled Round Ring Binders 1.928 2 0.8 -2.9884
4376 CA-2014-166954 4/25/2014 4/30/2014 Standard Class BT-11305 Beth Thompson Home Office United States San Gabriel California 91776 West FUR-FU-10003708 Furniture Furnishings Tenex Traditional Chairmats for Medium Pile Carpet, Standard Lip, 36” x 48” 303.250 5 0.0 63.6825
5116 CA-2017-125640 7/25/2017 7/29/2017 Standard Class DD-13570 Dorothy Dickinson Consumer United States Philadelphia Pennsylvania 19134 East OFF-LA-10004178 Office Supplies Labels Avery 491 3.304 1 0.2 1.0738
3373 CA-2017-123778 9/23/2017 9/30/2017 Standard Class BS-11755 Bruce Stewart Consumer United States San Francisco California 94122 West OFF-AP-10001242 Office Supplies Appliances APC 7 Outlet Network SurgeArrest Surge Protector 160.960 2 0.0 48.2880
1699 CA-2015-148376 12/27/2015 12/31/2015 Standard Class AG-10900 Arthur Gainer Consumer United States Los Angeles California 90008 West OFF-LA-10002381 Office Supplies Labels Avery 497 21.560 7 0.0 10.3488
3079 CA-2014-104780 5/21/2014 5/25/2014 Standard Class BT-11530 Bradley Talbott Home Office United States San Diego California 92037 West OFF-AR-10003514 Office Supplies Art 4009 Highlighters by Sanford 31.840 8 0.0 10.5072
9223 CA-2017-103212 10/13/2017 10/14/2017 First Class MH-18025 Michelle Huthwaite Consumer United States Lafayette Louisiana 70506 South OFF-PA-10004355 Office Supplies Paper Xerox 231 25.920 4 0.0 12.4416
9676 CA-2016-137393 5/6/2016 5/10/2016 Standard Class GM-14500 Gene McClure Consumer United States Bakersfield California 93309 West FUR-FU-10001617 Furniture Furnishings Executive Impressions 8-1/2” Career Panel/Partition Cubicle Clock 41.600 4 0.0 14.1440
1395 US-2017-117247 10/9/2017 10/14/2017 Standard Class CK-12760 Cyma Kinney Corporate United States Aurora Illinois 60505 Central FUR-TA-10002958 Furniture Tables Bevis Oval Conference Table, Walnut 652.450 5 0.5 -430.6170
9852 CA-2016-158155 5/2/2016 5/6/2016 Standard Class EH-13765 Edward Hooks Corporate United States New York City New York 10009 East OFF-BI-10001670 Office Supplies Binders Vinyl Sectional Post Binders 90.480 3 0.2 33.9300
4869 CA-2017-122490 11/13/2017 11/18/2017 Standard Class TT-21070 Ted Trevino Consumer United States Seattle Washington 98103 West OFF-LA-10001613 Office Supplies Labels Avery File Folder Labels 8.640 3 0.0 4.2336
8698 CA-2017-119284 6/15/2017 6/20/2017 Standard Class TS-21205 Thomas Seio Corporate United States Nashville Tennessee 37211 South FUR-FU-10004351 Furniture Furnishings Staple-based wall hangings 31.168 4 0.2 9.3504
8036 CA-2015-119690 6/25/2015 6/28/2015 First Class MV-17485 Mark Van Huff Consumer United States Houston Texas 77041 Central OFF-LA-10001613 Office Supplies Labels Avery File Folder Labels 4.608 2 0.2 1.6704
7378 CA-2014-132787 9/19/2014 9/23/2014 Standard Class MC-18130 Mike Caudle Corporate United States Seattle Washington 98115 West OFF-ST-10001321 Office Supplies Storage Decoflex Hanging Personal Folder File, Blue 92.520 6 0.0 24.9804
1732 CA-2014-125136 9/28/2014 10/3/2014 Standard Class KD-16495 Keith Dawkins Corporate United States Fayetteville North Carolina 28314 South OFF-PA-10001804 Office Supplies Paper Xerox 195 10.688 2 0.2 3.7408
1583 CA-2015-131338 8/9/2015 8/12/2015 First Class NP-18325 Naresj Patel Consumer United States New York City New York 10024 East OFF-BI-10000545 Office Supplies Binders GBC Ibimaster 500 Manual ProClick Binding System 1217.568 2 0.2 456.5880
8761 CA-2016-159891 1/31/2016 2/6/2016 Standard Class BF-11170 Ben Ferrer Home Office United States Atlanta Georgia 30318 South OFF-BI-10003527 Office Supplies Binders Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 1270.990 1 0.0 635.4950
9176 CA-2017-119424 6/12/2017 6/14/2017 Second Class SB-20185 Sarah Brown Consumer United States Kent Washington 98031 West OFF-PA-10001639 Office Supplies Paper Xerox 203 19.440 3 0.0 9.3312
4674 CA-2016-133550 7/31/2016 8/6/2016 Standard Class KL-16645 Ken Lonsdale Consumer United States Detroit Michigan 48205 Central TEC-PH-10001079 Technology Phones Polycom SoundPoint Pro SE-225 Corded phone 118.990 1 0.0 33.3172
6948 CA-2015-130365 4/25/2015 4/29/2015 Standard Class ZC-21910 Zuschuss Carroll Consumer United States Aurora Illinois 60505 Central OFF-ST-10002574 Office Supplies Storage SAFCO Commercial Wire Shelving, Black 221.024 2 0.2 -55.2560
8994 CA-2017-159100 10/16/2017 10/21/2017 Standard Class VP-21760 Victoria Pisteka Corporate United States Columbia Tennessee 38401 South FUR-TA-10001950 Furniture Tables Balt Solid Wood Round Tables 1875.258 7 0.4 -968.8833
199 US-2017-124303 7/6/2017 7/13/2017 Standard Class FH-14365 Fred Hopkins Corporate United States Philadelphia Pennsylvania 19120 East OFF-BI-10000343 Office Supplies Binders Pressboard Covers with Storage Hooks, 9 1/2” x 11”, Light Blue 2.946 2 0.7 -2.2586
2971 CA-2017-167941 11/6/2017 11/9/2017 Second Class JF-15565 Jill Fjeld Consumer United States Fayetteville North Carolina 28314 South OFF-BI-10002827 Office Supplies Binders Avery Durable Poly Binders 13.272 8 0.7 -10.6176
9076 US-2015-136259 11/5/2015 11/8/2015 First Class CB-12415 Christy Brittain Consumer United States Lakewood Ohio 44107 East OFF-BI-10000773 Office Supplies Binders Insertable Tab Post Binder Dividers 7.218 3 0.7 -5.5338
1938 CA-2016-112109 7/8/2016 7/12/2016 Standard Class JE-15715 Joe Elijah Consumer United States Broomfield Colorado 80020 West OFF-BI-10002082 Office Supplies Binders GBC Twin Loop Wire Binding Elements 19.968 2 0.7 -13.3120
1521 CA-2017-109946 4/16/2017 4/21/2017 Standard Class PL-18925 Paul Lucas Home Office United States Chicago Illinois 60610 Central OFF-AR-10001419 Office Supplies Art Newell 325 16.520 5 0.2 2.0650
1625 CA-2015-157084 12/19/2015 12/24/2015 Standard Class JG-15160 James Galang Consumer United States Los Angeles California 90049 West TEC-PH-10002922 Technology Phones ShoreTel ShorePhone IP 230 VoIP phone 675.960 5 0.2 84.4950
4382 CA-2015-152891 10/25/2015 10/30/2015 Standard Class TB-21625 Trudy Brown Consumer United States San Francisco California 94110 West FUR-TA-10001857 Furniture Tables Balt Solid Wood Rectangular Table 253.176 3 0.2 -31.6470
4207 CA-2014-145387 10/31/2014 11/2/2014 Second Class AM-10705 Anne McFarland Consumer United States Cranston Rhode Island 2920 East OFF-BI-10004001 Office Supplies Binders GBC Recycled VeloBinder Covers 34.080 2 0.0 15.6768
2704 CA-2014-143413 5/24/2014 5/30/2014 Standard Class RP-19390 Resi Plking Consumer United States Baltimore Maryland 21215 East OFF-PA-10002319 Office Supplies Paper Xerox 1944 116.280 3 0.0 56.9772
7317 CA-2016-132066 10/16/2016 10/20/2016 Standard Class NB-18655 Nona Balk Corporate United States New York City New York 10011 East FUR-TA-10001539 Furniture Tables Chromcraft Rectangular Conference Tables 142.182 1 0.4 -37.9152
9568 CA-2014-130428 3/31/2014 3/31/2014 Same Day TG-21640 Trudy Glocke Consumer United States Tampa Florida 33614 South OFF-AR-10004027 Office Supplies Art Binney & Smith inkTank Erasable Desk Highlighter, Chisel Tip, Yellow, 12/Box 4.032 2 0.2 1.0584
831 CA-2017-129462 6/16/2017 6/21/2017 Second Class JE-15745 Joel Eaton Consumer United States Florence Kentucky 41042 South OFF-AP-10003884 Office Supplies Appliances Fellowes Smart Surge Ten-Outlet Protector, Platinum 180.660 3 0.0 50.5848
2926 CA-2014-157721 9/2/2014 9/5/2014 First Class JM-16195 Justin MacKendrick Consumer United States Watertown New York 13601 East FUR-FU-10002116 Furniture Furnishings Tenex Carpeted, Granite-Look or Clear Contemporary Contour Shape Chair Mats 70.710 1 0.0 4.9497
5051 CA-2015-150511 9/18/2015 9/24/2015 Standard Class AB-10060 Adam Bellavance Home Office United States Des Moines Washington 98198 West OFF-PA-10001776 Office Supplies Paper Wirebound Message Books, Four 2 3/4” x 5” Forms per Page, 600 Sets per Book 18.540 2 0.0 8.7138
1848 CA-2017-128370 9/10/2017 9/10/2017 Same Day FH-14275 Frank Hawley Corporate United States Los Angeles California 90004 West FUR-CH-10002602 Furniture Chairs DMI Arturo Collection Mission-style Design Wood Chair 362.352 3 0.2 27.1764
246 CA-2014-131926 6/1/2014 6/6/2014 Second Class DW-13480 Dianna Wilson Home Office United States Lakeville Minnesota 55044 Central OFF-ST-10002276 Office Supplies Storage Safco Steel Mobile File Cart 166.720 2 0.0 41.6800
5093 CA-2015-119102 5/23/2015 5/27/2015 Standard Class KH-16690 Kristen Hastings Corporate United States Woonsocket Rhode Island 2895 East OFF-ST-10004507 Office Supplies Storage Advantus Rolling Storage Box 51.450 3 0.0 13.8915

Proftability

row

masRentable

$ 25,200

menosRentable

$ -8,880

row

Segments

row

Consumer % of sells

$ 134,119

row

Corporate % of sells

$ 91,979

row

Home Office % of sells

$ 60,299

Geographical

Shipments

row

row